KPI Ribbons

The ribbons in the KPI Designer change based on which stage of the designer it currently in focus.

Style

  • Run Button: click the Pyramid run button to test your KPI.
  • Choose Language: change the language for metadata and queries.
  • Translate Source: translate the formula name to be used for metadata and queries.
  • Refresh Metadata: refresh the data model metadata, including dimensions, elements, and business logic.
  • Internal Parameters: use this to open a dialog to see any one-off internal parameters defined and used in the KPI logic.
  • Quick Discovery: click to open the KPI Discover. Click here for more information.
  • Quick Logic: click to open the KPI Discover. Click here for more information.

Actuals

  • Target: from the Actual Value ribbon, insert the value that was assigned to the actual value. The entire formula configured for the Target Value will be copied to the Actual Value; this is useful if you want the actual to be driven by the target value. For example, you may want the actual value to be Target Value multiplied by 2, or some other manipulation of the target formulation.
  • Clipboard tools: use the clipboard tools to cut, copy, paste, and delete. You can also use keyboard shortcuts for these functions.
  • Choose Language: change the language for metadata and queries.
  • Translate Source: translate the formula name to be used for metadata and queries.
  • Refresh Metadata: refresh the data model metadata, including dimensions, elements, and business logic.
  • Internal Parameters: use this to open a dialog to see any one-off internal parameters defined and used in the KPI logic.
  • Script Mode: Click to switch to script mode and build you formula or list using PQL in the Custom Member IDE or the Custom List IDE.
  • Clear All: clear everything from the canvas.
  • Reset zoom to default: reset to the default zoom.
  • Quick Discovery: click to open the KPI Discover. Click here for more information.
  • Quick Logic: click to open the KPI Discover. Click here for more information.

Targets

  • Actual: from the Target Value ribbon, insert the value that was assigned to the target value.
  • Clipboard tools: use the clipboard tools to cut, copy, paste, and delete. You can also use keyboard shortcuts for these functions.
  • Choose Language: change the language for metadata and queries.
  • Translate Source: translate the formula name to be used for metadata and queries.
  • Refresh Metadata: refresh the data model metadata, including dimensions, elements, and business logic.
  • Internal Parameters: use this to open a dialog to see any one-off internal parameters defined and used in the KPI logic.
  • Script Mode: Click to switch to script mode and build you formula or list using PQL in the Custom Member IDE or the Custom List IDE.
  • Clear All: clear everything from the canvas.
  • Reset zoom to default: reset to the default zoom.
  • Quick Discovery: click to open the KPI Discover. Click here for more information.

Status

  • Templates: from the Status Value ribbon, select a KPI formula template from the Templates drop down.
  • Clipboard tools: use the clipboard tools to cut, copy, paste, and delete. You can also use keyboard shortcuts for these functions.
  • Choose Language: change the language for metadata and queries.
  • Translate Source: translate the formula name to be used for metadata and queries.
  • Refresh Metadata: refresh the data model metadata, including dimensions, elements, and business logic.
  • Internal Parameters: use this to open a dialog to see any one-off internal parameters defined and used in the KPI logic.
  • Script Mode: Click to switch to script mode and build you formula or list using PQL in the Custom Member IDE or the Custom List IDE.
  • Clear All: clear everything from the canvas.
  • Reset zoom to default: reset to the default zoom.
  • Quick Discovery: click to open the KPI Discover. Click here for more information.
  • Quick Logic: click to open the KPI Discover. Click here for more information.